package cc.angis.xiugallery.db;


public class TableConstants {

	public static String TABLE_FAVOURITE = "favourite";
	
	public static String TABLE_FAVOURITE_IMAGES = "favourite_images";
	
	public static String TABLE_IMAGE_DESC = "image_desc";
	
	public static String TABLE_USER_ACCOUNT = "user_account";
	
	public static String TABLE_POST = "post";
	
	public static String TABLE_POST_PLATFORM = "post_platform";
	
	public static String TABLE_COMMENT = "comment";
	
	public static class FavouriteColumn {
		public static String ID = "id";
		public static String NAME = "name";
		public static String LASTUPDATE = "lastupdate";
		public static String LASTIMAGEID = "lastimgid";
		public static String IMGCOUNT = "imgcount";
	}
	
	public static class FavouriteImagesColumn {
		public static String ID = "id";
		public static String FAVID = "favid";
		public static String IMGID = "imgid";
//		public static String FAVNAME = "favname";
	}
	
	public static class ImageDescColumn  {
		public static String ID = "id";
		public static String IMGID = "imgid";
		public static String TYPE = "type";
		public static String DESC_TEXT = "desctext";
		public static String VOICE_PATH = "voicepath";
	}
	
	public static class UserAccount {
		public static String ID = "id";
		public static String USER_ID = "uid";
		public static String ACCESS_TOKEN = "accesstoken";
		public static String EXPIRED_IN = "expiredin";
		public static String USERNAME = "username";
		public static String ACCOUNT_TYPE = "accounttype";
		public static String AVATAR = "avatar";
	}
	
	public static class PostColumn {
		public static String ID = "id";
		public static String POSTID = "postid";
		public static String IMGID = "imgid";
		public static String CONTENT = "content";
		public static String POST_TIME = "posttime";
		public static String COMMENT_COUNT = "commentcount";
		public static String LASTUPDATE = "lastupdate";
	}
	
	public static class PostPlatFormColumn {
		public static String ID = "id";
		public static String POSTID = "postid";
		public static String PLATFORMID = "platformid";
		public static String PLATFORMTYPE = "platformtype";
	}
	
	public static class CommentColumn {
		public static String ID = "id";
		public static String COMMENT_ID = "comment_id";
		public static String POST_ID = "postid";
		public static String COMMENT_TIME = "commenttime";
		public static String COMMENT_TYPE = "commenttype";
		public static String CONTENT = "content";
		public static String AUTHOR = "author";
		public static String AVATAR = "avatar";
	}

}
